|
오라클 실습 |
[1] |
|
등록일:2009-05-28 00:18:35 (0%) 작성자: 제목:2. 정확히 10위까지만 구하라. |
|
Select rownum, sal, ename, job, empno
From emp e1
Where 10 > (select count(*) from emp e2
Where e2.sal > e1.sal)
Order by sal desc; |
[본문링크] 2. 정확히 10위까지만 구하라.
|
[1]
|
|
|
|
|
코멘트(이글의 트랙백 주소:/cafe/tb_receive.php?no=31508 |
|
|
|
|
|
|
|
|
|
Copyright byCopyright ⓒ2005, SSISO Community All Rights Reserved.
|
|
|